HW#5 --- last modified February 17 2019 19:38:27..

Solution set.

Due date: May 13

Files to be submitted:
  Hw5.zip

Purpose: To learn and experiment more with DB2 commands tools and performance.

Related Course Outcomes:

The main course outcomes covered by this assignment are:

(2) Describe the system environment of DB2 on z/OS, understand how DB2 cooperates with other facilities within this environment.

(4) Understand DB2 performance issues and know how to manage them.

(5) State basic DB2 management issues.

Specification:

Your Hw5.zip file should contain two main files: Assignment.html and Lab.php . The assignment file should contain your solutions to the multiple choice problems below. The lab file should contain transcripts and screenshots from your SPUFI and control center sessions as well as anything else needed to assignment the lab portion of the assignment.

Assignment Component

For this portion you should answer the following multiple choice problems. To do this you might need to examine the online DB2 Reference Center. Besides choosing what you think is the correct answer to each question you should provide a short explanation in your own words justifying your answer. An answer without a coherent justification will not receive any credit.

1. Given the situation:
   You selected your airline ticket from a price comparing website and found the lowest one is $100 provided by a local ticket agency. Then you proceed to book it. After you confirmed your order you realized that the price has risen to $150 right after your in-quiry and your credit card is charged for $150. You were very angry because you could have bought ticket from another agency that still marks and sells it at $120.
   1. Phantom Row Anomaly
   2. Non-repeatable Read
   3. Dirty Read Anomaly
   4. Lost Update Anomaly
2. Which of the following isolation level that sets the minimum requirement to prevent the anomaly mentioned in question (1)?
   1. Repeatable Read (RR).
   2. Read Stability (RS).
   3. Cursor Stability (CS).
   4. Uncommitted Read (UR).
3. Which of the following information is not taken down into logs?
   1. Undo records for an update
   2. Redo records for an update
   3. Page set information
   4. Data set open/close
   5. Checkpoint information
   6. Trace information
4. A complete check point contains which of the following information?
   1. A list of information about each active UR.
   2. Information about each open table space and index space.
   3. Start and end checkpoint log records.
   4. System status including memory and CPU usage.
   1. i, iii
   2. i, ii, iii
   3. ii, iii, iv
   4. All of the above
5. Which of the following is a characteristic of a normal shutdown?
   1. It may take a long time.
   2. It has a quiesce process which allows all the ongoing transactions to complete and does not allow new transactions to come in.
   3. All active logs are archived to archive logs.
   4. All the updated pages are externalized to DASD data sets.
   1. i, ii, iii
   2. ii, iii, iv
   3. i, ii, iv
   4. all of them above
6. In the Current Status Rebuild phase of the recovery process, how does DB2 know where to begin the forward recovery processing?
   1. It's the last complete checkpoint, located from BSDS
   2. It's a checkpoint preceding the oldest pending write associated with every open page set.
   3. It's the checkpoint preceding the oldest incomplete UR
   4. It's the starting point of the oldest incomplete UR.
7. We can use DISPLAY UTILITY command to:
   1. View utilities available in your DB2 system.
   2. Monitor utilities in progress.
   3. Retrieve manuals on how to use this utility.
   4. Display utilities with execution errors.
8. Which of the following commands is used to stop all application threads?
   1. STOP THREAD(*)
   2. CANCEL THREAD(*)
   3. TERM THREAD(*)
   4. SUSPEND THREAD(*)
9. Which of the following information can be generated by DIAGNOSE?
   1. OBD of the table space and/or index space
   2. Records from SYSIBM.SYSUTIL
   3. Module entry-point lists (MEPLs)
   4. All of the above
10. Which of the following facilities monitors the disk usage?
    1. RMF
    2. SMF
    3. DDF
    4. QMF
11. Which of the following statements is true for list prefetch?
    1. It's considered when the cluster ratio on the indexable predicates is high.
    2. Cannot be used in combination with a non-matching index scan.
    3. It involves sorting with RID.
    4. The result of a list prefetch is an ordered set to users.
12. When you query the DB2 catalog, how many of the following fields can you filter on?
    1. Name
    2. Grantor
    3. Grantee
    4. Owner
    1. 1
    2. 2
    3. 3
    4. 4

Lab Component

Varian has now posted Labs 11. To do the lab component of this homework, go through these labs answering the questions therein. Keep a transcript of your SPUFI sessions. Put these all into Lab.html). Use the same manual method for creating html files as was used for Hw5.

Point Breakdown